lyfz_repos/铂金版源码/DBFile/SQL/2015-08-13[收集]/2015-09-15(胡工).sql

if not exists
(select * from [tb_ErpSystemConfigure] where [Sconfig_Code]='PhotographersEarly')
begin
INSERT [tb_ErpSystemConfigure] ([Sconfig_Code],[Sconfig_Name],[Sconfig_Value],[Sconfig_IsEnabled],[Sconfig_Remark],[Sconfig_Order],[Sconfig_CreateDatetime])
VALUES ('PhotographersEarly','摄影师也有前期业绩','1',1,'摄影师也有前期业绩','','2015/9/14 17:38:54')
end
GO
if not exists
(select * from [tb_ErpSystemConfigure] where [Sconfig_Code]='MakeupArtistEarly')
begin
INSERT [tb_ErpSystemConfigure] ([Sconfig_Code],[Sconfig_Name],[Sconfig_Value],[Sconfig_IsEnabled],[Sconfig_Remark],[Sconfig_Order],[Sconfig_CreateDatetime])
VALUES ('MakeupArtistEarly','化妆师也有前期业绩','1',1,'化妆师也有前期业绩','','2015/9/14 17:38:54')
end
GO
if not exists
(select * from [tb_ErpSystemConfigure] where [Sconfig_Code]='BootDivisionEarly')
begin
INSERT [tb_ErpSystemConfigure] ([Sconfig_Code],[Sconfig_Name],[Sconfig_Value],[Sconfig_IsEnabled],[Sconfig_Remark],[Sconfig_Order],[Sconfig_CreateDatetime])
VALUES ('BootDivisionEarly','引导师也有前期业绩','1',1,'引导师也有前期业绩','','2015/9/14 17:38:54')
end
GO
if not exists
(select * from [tb_ErpSystemConfigure] where [Sconfig_Code]='FirstRepairDivisionEarly')
begin
INSERT [tb_ErpSystemConfigure] ([Sconfig_Code],[Sconfig_Name],[Sconfig_Value],[Sconfig_IsEnabled],[Sconfig_Remark],[Sconfig_Order],[Sconfig_CreateDatetime])
VALUES ('FirstRepairDivisionEarly','初修师也有前期业绩','1',1,'初修师也有前期业绩','','2015/9/14 17:38:54')
end
GO
if not exists
(select * from [tb_ErpSystemConfigure] where [Sconfig_Code]='FinishingDivisionEarly')
begin
INSERT [tb_ErpSystemConfigure] ([Sconfig_Code],[Sconfig_Name],[Sconfig_Value],[Sconfig_IsEnabled],[Sconfig_Remark],[Sconfig_Order],[Sconfig_CreateDatetime])
VALUES ('FinishingDivisionEarly','精修师也有前期业绩','1',1,'精修师也有前期业绩','','2015/9/14 17:38:54')
end
GO
if not exists
(select * from [tb_ErpSystemConfigure] where [Sconfig_Code]='DesignersEarly')
begin
INSERT [tb_ErpSystemConfigure] ([Sconfig_Code],[Sconfig_Name],[Sconfig_Value],[Sconfig_IsEnabled],[Sconfig_Remark],[Sconfig_Order],[Sconfig_CreateDatetime])
VALUES ('DesignersEarly','设计师也有前期业绩','1',1,'设计师也有前期业绩','','2015/9/14 17:38:54')
end
GO
if not exists
(select * from [tb_ErpSystemConfigure] where [Sconfig_Code]='PhotographerSelectionFilms')
begin
INSERT [tb_ErpSystemConfigure] ([Sconfig_Code],[Sconfig_Name],[Sconfig_Value],[Sconfig_IsEnabled],[Sconfig_Remark],[Sconfig_Order],[Sconfig_CreateDatetime])
VALUES ('PhotographerSelectionFilms','摄影师也有选片二销业绩','1',1,'摄影师也有选片二销业绩','','2015/9/14 17:38:54')
end
GO
if not exists
(select * from [tb_ErpSystemConfigure] where [Sconfig_Code]='MakeupArtistSelectionFilms')
begin
INSERT [tb_ErpSystemConfigure] ([Sconfig_Code],[Sconfig_Name],[Sconfig_Value],[Sconfig_IsEnabled],[Sconfig_Remark],[Sconfig_Order],[Sconfig_CreateDatetime])
VALUES ('MakeupArtistSelectionFilms','化妆师也有选片二销业绩','1',1,'化妆师也有选片二销业绩','','2015/9/14 17:38:54')
end
GO
if not exists
(select * from [tb_ErpSystemConfigure] where [Sconfig_Code]='GuideSelectionFilmsDivision')
begin
INSERT [tb_ErpSystemConfigure] ([Sconfig_Code],[Sconfig_Name],[Sconfig_Value],[Sconfig_IsEnabled],[Sconfig_Remark],[Sconfig_Order],[Sconfig_CreateDatetime])
VALUES ('GuideSelectionFilmsDivision','引导师也有选片二销业绩','1',1,'引导师也有选片二销业绩','','2015/9/14 17:38:54')
end
GO
if not exists
(select * from [tb_ErpSystemConfigure] where [Sconfig_Code]='FirstRepairDivisionSelectionFilms')
begin
INSERT [tb_ErpSystemConfigure] ([Sconfig_Code],[Sconfig_Name],[Sconfig_Value],[Sconfig_IsEnabled],[Sconfig_Remark],[Sconfig_Order],[Sconfig_CreateDatetime])
VALUES ('FirstRepairDivisionSelectionFilms','初修师也有选片二销业绩','1',1,'初修师也有选片二销业绩','','2015/9/14 17:38:54')
end
GO